Stored Procedures [dbo].[asi_DocumentLinkDocument]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@folderHierarchyKeyuniqueidentifier16
@documentVersionKeyuniqueidentifier16
SQL Script
-- links a document into a folder using the hierarchy.  The FolderHierarchyKey points to the parent folder
CREATE PROCEDURE [dbo].[asi_DocumentLinkDocument]
   @folderHierarchyKey uniqueidentifier,
   @documentVersionKey uniqueidentifier
AS
DECLARE
   @hierarchyKey uniqueidentifier
BEGIN
   exec asi_DocumentLinkDocumentOut @folderHierarchyKey, @documentVersionKey, @hierarchyKey output
   -- return the key found or created
   SELECT @hierarchyKey AS HierarchyKey
END

GO
Uses
Used By